create external table jms_ods.yl_oms_interceptorpiece_extend
(
  logistics_id  string ,
  cp_code       string,
  mail_no       string,
  extend_fields string,
  create_time   timestamp,
  update_time   timestamp,
  apply_source  int comment '申请来源'
)
COMMENT '拦截件拓展表'
PARTITIONED BY (
  `dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS parquet
LOCATION
  '/dw/hive/jms_ods.db/external/yl_oms_interceptorpiece_extend';